Skip to main content

multikey_lookup

1. Description​

The Multikey Lookup Calculation Type is used to extract a field from master file based on the keys present in input file and master file. This Calculation Type is used when there are multipe keys to lookup into the master file.

2. Screen Configuration​

multikey_lookup_image

Both the values "AccNum" amd "CurrId" of base input files are concatenated. Also "cid" and "CustomerGroupId" are concatenated from reference file.These concatenated value from base input file is searched in the concatenated value of reference file.If it is present then "CustomerGroupId" is assigned to "GLCode" else default value "Cust" is assigned. "Cust" should be declared in additional derivatives.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "F64","I64" or "String".
  • derivation
    • derivation_type: The calculation type used to derive this output field, which for multikey lookup is "MULTIKEY_LOOKUP".
    • req_fields
      • input_keys: Field names from the input metadata / output config to be the key to do lookup in master file.
      • master_name: Name of the master file configured in input config.
      • master_keys: Field names from the master metadata to be the key which needs to be looked up.
      • master_value: Field name from the master metadata which needs to be derived.
      • default_value: Field name from input metadata or output config or constants metadata which needs to be derived when input key is not found in master file.